Motivation for the Project

Seattle, one of the most popular cities in the US, is known to have a high population.
Due to its high population, crime is unavoidable in the city. Recognizing the concern, we desire to create a data visualization that visually conveys the type and location of reported crimes.

We are interested in the topic because identifying patterns in past crimes not only help professionals make informed decisions to combat the war with crime but also informs the general public about the critical information regarding public safety. Police officers, government officials, and others can use insights from this data to try implementing and enforcing different solutions to reduce crime rates. We believe that this type of data-driven decision making can have a positive impact on cities all around the world.

To obtain credible data, we collected our data sources are from Seattle.gov. The Seattle Police Department created all three data that we used for the project. Dataset 1 provides information about criminal incidents from 2008-present day, as well as the type of crime, its location, and how frequently that type occurs.

Crime Information by Sector
Sectors Total Primary Offenses Most Occured Crime Frequency Most Occured Crime Number of Call Logs
BOY 74 8 Assault 64
CHARLIE 35 9 Assault 34
DAVID 71 9 Assault 73
EDWARD 53 8 Assault 54
FRANK 53 9 Assault 46
GEORGE 51 9 Assault 53
JOHN 39 9 Assault 44
KING 82 8 Assault 96
LINCOLN 56 9 Assault 48
MARY 79 6 Assault 85
NORA 50 9 Assault 51
NULL 50 9 Assault 15
OCEAN 26 9 Assault 38
QUEEN 73 8 Assault 44
ROBERT 71 9 Assault 73
SAM 60 8 Homicide 74
UNION 60 8 Assault 55
WILLIAM 38 9 Burglary 53
### Added description and insights of agg table -Yunwei

Crime Report from 2008-present day

A precinct is an area whose boundaries are determined by the police for their investigative purposes. As indicated by this graph, the North precinct of Seattle is the most dangerous based on the number of crimes that have occured from 2008 to present day.

Relations of Crime and Call Data

(from SPD Communications Center)

get rid of pie chart later- yunwei

This data comes from Seattle Police Department’s Communications Center’s record of log calls, including 911 calls, etc.The pie chart shows the top 10 most common Initial Call Type received from 2008 to present day. Of these call types, the most common ones are simple Premise Checks and Traffic Violations. However, there are also more serious crimes such as Burglary and Narcotics. ### delet this pie chart section -yunwei

Number of Crime Reports in Seattle Neighborhood

This data comes from The Seattle Police Department provided this data on the Seattle.gov website. It includes information about the crime that was reported in different neighborhoods in Seattle. There are total 524k rows, and 11 columns and each row is a unique crime reported record. The visualization focused on the number of crime reports in different neighborhoods in Seattle